package edu.friday.repository;

import edu.friday.model.SysRole;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

//JpaRepository：一个数据库的连接工具
@Repository
//前面规定实体类的类型，如SysRole，后面规定数据表的主键类型，这里用的是Long
public interface SysRoleRepository extends JpaRepository<SysRole, Long> {
    @Query(value = " select r.role_id from sys_role r "+
                    " left join sys_user_role ur on ur.role_id = r.role_id" +
                    " left join sys_user u on u.user_id = ur.user_id" +
                    " where r.del_flag = '0' and u.user_id = :userId ",nativeQuery = true)
    List<Long> selectRoleIdsByUserId(Long userId);
}
